﻿if exists(SELECT * FROM sys.objects o WHERE o.[object_id]= OBJECT_ID('V_ProductMemberRankPrice') AND o.[type]=N'V')
BEGIN
	DROP VIEW V_ProductMemberRankPrice
END
GO
	create View V_ProductMemberRankPrice
	as
	select  
		[Guid]
      ,[ProductGuid]
      ,[MemberRankGuid]
      ,[Price] 
	from ShopNum1_ProductMemberRankPrice where IsDeleted=0